How to: Use AutoCalculate for functions other than SUM().
Solution:
Select the range that needs to be calculated, right-click 'AutoCalculate', and select the desired function.
1) Select the range to be calculated.
NOTE: The sum of the selected range is automatically displayed on the status bar. If the status bar is not displayed, select the 'View' menu and select 'Status Bar' to display it.
the Status Bar
2) Right-click on the 'AutoCalculate' on the status bar. (A list of available functions appears.)
Right-clicking on the 'AutoCalculate'
3) Select the desired function. (The result of the selected function displays on the status bar.)
NOTE: Once the function is selected, it will be used to AutoCalculate all the selected ranges until it is changed again.
